create database Blogs

go
use Blogs

go
create table Users
(Id int primary key identity, 
Username nvarchar(80) not null,
Password nvarchar(80) not null)

insert into Users(UserName,PassWord)values('sa','123456')

create table Articles
(Id int primary key identity ,
Title nvarchar(80) not null,
Author nvarchar(80) not null,
CreatedTime DateTime default getdate())


insert into Articles(Title,Author) values ('RNG','UZI')
insert into Articles(Title,Author) values ('EDG','Clearlove')
insert into Articles(Title,Author) values ('IG','Theshy')
insert into Articles(Title,Author) values ('FPX','Doinb')

select * from Users

select * from Articles